IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].GetPastDueDays') AND type in (N'P', N'PC'))
DROP PROCEDURE dbo.GetPastDueDays
GO

CREATE PROCEDURE dbo.GetPastDueDays  
AS  
BEGIN  
  
 CREATE TABLE #MyTempTable (ProjectDueDays INT, Description varchar(100));  
 INSERT INTO #MyTempTable VALUES (30, '30');  
 INSERT INTO #MyTempTable VALUES (60, '60');  
 INSERT INTO #MyTempTable VALUES (90, '90');  
 INSERT INTO #MyTempTable VALUES (0, '> 90');
  
 select * from #MyTempTable  
  
 drop table #MyTempTable  
  
END  